______________ Pict_AA999__Func__!___ DEPT_______ Department _______ C_ _4__ __ ______________________ __________________ Pict________Func__!___ LNAME______ Last Name_________ C_ _25_ __ ______________________ __________________ Pict________Func______ FNAME______ First Name________ C_ _20_ __ ______________________ __________________ EMPDATE LNAME EMPID ______________ __________________ Pict________Func______ STATE______ State_____________ C_ _2__ __ ______________________ __________________ Pict__AA____Func__!___ ZIP________ Zip Code__________ C_ _10_ __ ____99999-9999________ __________________ Pict________Func______ EMPDATE____ Employment Date___ D_ _8__ __ ______________________ __________________ Pict________Func______ ACTIVE_____ Is Active?________ L_ _1__ __ ______________________ __________________ Pict________Func__Y___ COMMENTS___ General Info______ M_ _10_ __ ______________________ __________________ Pict________Func______ SKILLS_____ Skills____________ C_ _25_ __ __PICK LIST___________ __________________ Pict________Func______ PHONE______ Home Phone Number_ C_ _14_ __ __(999) 999-9999______ __________________ Pict________Func______ R 65,J,T 5 STEP 8 - Query Worksheet During the DEFINE Phase it was learned that EMPDATE EMPDATE LNAME Barry Zoellner LNAME 04563 78965 EMPID BA100 ZO100 EMPID LNAME+FNAME Barry Kevin Zoellner Leigh LNAME AFNAME PROG Barry Bonnacker Brooks Bruce Bruce Bryan Cognac Connors Jonah Kathleenovitch Lacroux Lacroux Marie Middleton Randall Ridley Troutman Zoellner 04563 09876 7896r 22234 0198 23456 23456 23456 30024 ru 30335 30350 or 33897 33931 0768 34109 2356 34567 3109 38912 2323 45367 7769 67543 $ 67895 8765 78965 Bonnacker Brooks Bruce Bruce Bryan Cognac Connor Jonah Kathleenovitch Lacroux Lacroux Marie Middleton Randall Ridley Troutman Zoellner BA100 BO100ORP BR100 BR200IS BR300 CO100ROG CO200 JO100ROG KA100 LA100ROG LA200 MA100ORD MI100 RA100 RI100 TR100 TR200 ZO100 Barry Kevin Bonnacker Jeff Brooks Stuart Bruce Charles Bruce Robert Bryan Christopher Cognac Kael Connors Bonnie Jonah Allison Kathleenovitch Holly Lacroux Blaise Lacroux Jean Marie Lisa Middleton Sally Randall Joseph Ridley Nell Troutman George Zoellner Leigh